package com.itheima.mm.mapper;

import com.github.pagehelper.Page;
import com.itheima.mm.entity.IndustryPageQueryParams;
import com.itheima.mm.pojo.Industry;
import com.itheima.mm.vo.CourseVO;
import com.itheima.mm.vo.IndustryVO;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Description IndustryMapper
 * @Author xiao
 * @Date 2024-06-26
 */

@Mapper
public interface IndustryMapper {



    //根据行业表获取全部的行业信息
    @Select("select * from t_industry")
    List<Industry> selectListAll();

//根据公司（企业）id查询行业方向列表，使用xml文件映射
    List<Industry> selectIndustryListByCompany(Integer id);

    Page<IndustryVO> findByConditon(IndustryPageQueryParams queryParams);

    void add(Industry industry);

    @Delete("delete from t_industry where id = #{id}")
    void delete(Integer id);
}
